2015-06-26 - 20243 - Service Request - WMS501 - VAS exception #CrystalReportsSupport

2015-06-26 - 20243 - Service Request - WMS501 - VAS exception

Problem Summary

---

Need to exclude a new set of UPC's from WMS500/WMS501 reports, those UPC's begin with 195 and are 12 digits long.

Admin Info

---

Purpose	Need to exclude a new set of UPC's from WMS500/WMS501 reports.
Requested by	Carl Klein
Issue Date	06-26-2015
Resolved by	Venkateswara Reddy D
Resolved Date	12-21-2012
Document Status	Complete

Detailed Problem Description

---

Email from Mark G on 06/26/2015:

The new set of external UPC numbers that we have all start with a 1 now: The new EXTERNAL UPCs start with 195XXXXXX. We exhaust that 195 number set we will move onto another set. Can the logic that the report runs on be updated to look for blanks and for any UPC number that is less than 12 digits long? The internal UPC numbers that we have are shorter that the external.

Solution Analysis and Recommendations

---

1. Need to analyze the formulas and filters in the report.
2. Need to change the formula as mentioned below.

Resolution

---

1. Need to analyze the formulas and filters in the report.
2. Need to change the formula Condition4 as follows:

If {ZSDVAS.J_3AVASSO-J_3ASSTYP} IN ["S01","S02","S03","S04","S05","S06","S07","S08","S09","S10","S11","S12","S13","S14","S15","S16","S17","S18","S19","S20","S22","S23","S24","S25","S26","S27","S28","S29","S30","S31","S32","S33"]
and not({ZSDVAS.VBAK-KUNNR} in ["1006296","1009280"])
and ((Length({ZSDVAS.VBEP-J_3AEAN11}) >= 12) and (LEFT({ZSDVAS.VBEP-J_3AEAN11},3) = "195"))
then
0
else If {ZSDVAS.J_3AVASSO-J_3ASSTYP} IN ["S01","S02","S03","S04","S05","S06","S07","S08","S09","S10","S11","S12","S13","S14","S15","S16","S17","S18","S19","S20","S22","S23","S24","S25","S26","S27","S28","S29","S30","S31","S32","S33"]
and not({ZSDVAS.VBAK-KUNNR} in ["1006296","1009280"])
and ({ZSDVAS.VBEP-J_3AEAN11} = "" or (LEFT({ZSDVAS.VBEP-J_3AEAN11},1) = "1") )
then
1
else
0

3. Need to update all formatting changes based on NEC standards.

Test Plan

Test ID	Test Scenario	Expected Results
1	Report Format.	Should be as per NEC crystal standard checklist.
2	Execute Crystal Report in Crystal Designer tool after changes.	Report should execute successfully in Crystal Designer tool.
3	Schedule the Report in NEC BI Launch Pad.	Report should execute successfully in NEC BI Launch Pad.

Release Information

---

None